When a key is absent from both the config file and the environment variables, the default value is used. The single backslash is interpreted as an escape sequence start within Java properties. All settings in the configuration file can be set or overridden using environment variables. If a key is set in both the server. To make these configuration settings available to QuestDB via environment variables, they must be in the following format:. To properly format a server.
QuestDB applies these configuration changes on startup and a running instance must be restarted in order for configuration changes to take effect. The following configuration property customizes the number of worker threads shared across the application:. Certain configuration settings can be reloaded without having to restart the server. To reload a setting, edit its value in the server.
Each key has a reloadable property that indicates whether the key can be reloaded. This section lists the configuration keys available to QuestDB by topic or subsystem. Shared worker threads service SQL execution subsystems and in the default configuration every other subsystem. Number of worker threads shared across the application. Increasing this number will increase parallelism in the application at the expense of CPU resources.
Comma-delimited list of CPU ids, one per thread specified in shared. By default, threads have no CPU affinity. For details on the use of this component, refer to the web console documentation page. A value of 0 means that the HTTP server will bind to all network interfaces. You can specify IP address of any individual network interface on your system. The rationale of the value is to control server memory consumption.
Soft limit for simultaneous HTTP query connections. When breached, new connections will be rejected but existing connections won't be closed immediately as long as http. Soft limit for simultaneous ILP connections. TCP connection idle timeout in milliseconds. Connection is closed by HTTP server when this timeout lapses. Maximum send buffer size on each TCP socket. If this value is -1 , the socket send buffer size remains unchanged from the OS defaults.
